SQL Commands sccm checkdb
Hi: I'm trying to set up a couple of SQL maintenance commands to check the size of the data base and check for errors.
If I get this to work I may look into shrinking the data base or truncating the logs.
I've got the check data base space working ok:
SQL command: sp_spaceused
Log status to: \\mySCCMsiteServer\logs\dbspace.log
but the check data base isn't going so well:
SQL command: DBCC CHECKDB (SMS_T21)
Log status to: \\mySCCMsiteServer\logs\dbcheck.log
This produces this log:
********
Usage: INVWIN32 <options>
Options:
--------
<Check the SCCM database>: 'DBCC CHECKDB (SMS_T21)' : 5/4/2008 12:03 AM
********
<Check the SCCM database>: 'DBCC CHECKDB (SMS_T21)' : 5/4/2008 12:05 AM
********
/S signifies that this is a stand-alone workstation
<Check the SCCM database>: 'DBCC CHECKDB (SMS_T21)' : 5/4/2008 12:05 AM
I've run this same command in my SQL Server management studio and it works fine and outputs a long list with no errors at the bottom.
Testing is a little hard because I make a change and then wait 24 hours to see how it did.
I've tried this on two isolated labs and my production server with the same results.
I've searched for info about INVWIN32 but can't find the file on my server or workstation,orany useful informationrelating to SCCM.
Any help or redirection would be great.
May 4th, 2008 9:17pm
I'll try the square barackets and let you know.
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2008 10:26pm
DBCC CHECKDB [SMS_CO1] got the same results:
********
Usage: INVWIN32 <options>
Options:
--------
<Check the SCCM database>: 'CHECKDB [SMS_TR1]' : 5/6/2008 12:00 AM
********
/I specifies the INVWIN32 to collect inventory only
<Check the SCCM database>: 'DBCC CHECKDB [SMS_TR1]' : 5/6/2008 12:00 AM
May 6th, 2008 3:43pm